USE [QuanLi]
GO

/****** Object:  Table [dbo].[NSTrinhDoChuyenMon]    Script Date: 12/03/2011 11:08:45 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[NSTrinhDoChuyenMon](
	[TrinhDoChuyenMonID] [int] IDENTITY(1,1) NOT NULL,
	[NhanVienID] [int] NOT NULL,
	[TrinhDoChuyenMonCaoNhatID] [int] NOT NULL,
	[NgayHieuLuc] [date] NULL,
	[GhiChu] [nchar](10) NULL,
 CONSTRAINT [PK_NSTrinhDoChuyenMon] PRIMARY KEY CLUSTERED 
(
	[TrinhDoChuyenMonID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[NSTrinhDoChuyenMon]  WITH CHECK ADD  CONSTRAINT [FK_NSTrinhDoChuyenMon_NSNhanVien] FOREIGN KEY([NhanVienID])
REFERENCES [dbo].[NSNhanVien] ([NhanVienID])
GO

ALTER TABLE [dbo].[NSTrinhDoChuyenMon] CHECK CONSTRAINT [FK_NSTrinhDoChuyenMon_NSNhanVien]
GO

ALTER table  dbo.NSNhanVien drop column TrinhDoChuyenMonCaoNhatID
			  

